﻿namespace Citi.PTSConsolidation.Domain
{
    public class EntrepotDatabaseNames
    {
        public class ApplicationBookOfWork
        {
            public const string TableName = "[dbo].[vw_MasterQuery_Financials_App]";

            public const string ApplicationId = "[Application_Id]";
            //public const string ApplicationName = "[App_Name]";
            //public const string ApplicationRetirementDate = "App_Retirement_date";

            public const string PeriodYear = "[PeriodYear]";
            public const string AccountLevel1 = "Financials.[Account_Level_1]";
            public const string AccountLevel2 = "[Account_Level_2]";
            public const string AccountLevel3 = "[Account_Level_3]";
            public const string InitiativeId = "[Initiative_Id]";
            public const string InitiativeName = "[INITIATIVE_NAME]";
            public const string ProgramId = "[Program_Id]";
            public const string ProgramName = "[PROGRAM_NAME]";
            public const string ProjectId = "Financials.[Project_Id]";
            public const string ProjectName = "[PROJECT_NAME]";
            public const string ProgramManager = "[Program_Manager]";
            public const string ProgramStartDate = "[PROG_START_DATE]";
            public const string ProgramEndDate = "[PROG_END_DATE]";

            public const string ProjectStatus = "[PROJECT_STATUS]";
            public const string ProjectStartDate = "[PROJECT_START_DATE]";
            public const string ProjectEndDate = "[PROJECT_END_DATE]";
            public const string ProjectManager = "[PROJECT_MANAGER]";

            public const string BillingClientGocCode = "[Billing_Client_Goc_Code]";

            public const string Client3Name = "[Client_3_name]";
            public const string Client4Name = "[Client_4_name]";
            public const string Client5Name = "[Client_5_name]";
            public const string Client6Name = "[Client_6_name]";
            public const string Client7Name = "[Client_7_name]";
            public const string Client8Name = "[Client_8_name]";
            public const string Client9Name = "[Client_9_name]";
            public const string Client10Name = "[Client_10_NAME]";
            public const string ClientGocCode = "[CLIENT_GOC_CODE]";
            public const string ClientRegion = "[Client_Region]";

            public const string System5Name = "[System_5_name]";
            public const string System6Name = "[System_6_name]";
            public const string System7Name = "[System_7_name]";
            public const string System8Name = "[System_8_name]";
            public const string System9Name = "[System_9_name]";
            public const string System10Name = "[System_10_name]";
            public const string SystemGocCode = "[SYSTEM_GOC_CODE]";
            public const string SystemRegion = "[System_Region]";

            public const string Lob = "[LOB]";

            public const string RuntheBankBuildTheBank = "[RuntheBankBuildtheBank]";
            public const string ProgramProjectLinkIndicator = "[PROGRAM_PROJECT_LINK_INDICATOR]";
            public const string WorkTypeFinancials = "[Work Type Financials]";
            public const string InitiativeInvestCategory = "[INIT_INVEST_CATEGORY]";
            public const string ProgramInvestimentCategory = "[PROG_INVEST_CATEGORY]";
            public const string ProgramCapitalizedIndicator = "[PROG_CAPIND]";
            public const string ProgramStatus = "[PROGRAM_STATUS]";

            public const string ProjectCapitalization = "[Project_Capitalization]";

            public const string BowFlag = "[BOW Flag]";
            public const string BowFlag2 = "[BOW Flag2]";
            public const string ProjectType = "[Project_Type]";

            public const string ProgramCarryoverIndicator = "[PROGRAM_CARRYOVER_INDICATOR]";
            public const string TaxonomyName = "[TAXONOMYNAME]";

            public const string CuRate = "[CU_Rate]";
            public const string FirstOfProgramDescr = "[FirstOfPROGRAM_DESC]";
            public const string LobParent = "[LOB_PARENT]";
            public const string AdjustedFlag = "[Adjusted_Flag]";

            public const string January = "[January]";
            public const string February = "[February]";
            public const string March = "[March]";
            public const string April = "[April]";
            public const string May = "[May]";
            public const string June = "[June]";
            public const string July = "[July]";
            public const string August = "[August]";
            public const string September = "[September]";
            public const string October = "[October]";
            public const string November = "[November]";
            public const string December = "[December]";

            public const string YearToDate = "[YearToDate]";
            public const string FullYear = "[FullYear]";
        }

        public class BookOfWork
        {
            public const string TableNameCurrentYear = "[dbo].[vw_MasterQuery_ALL_CurrentYear]";
            public const string TableNameNextYear = "[dbo].[vw_MasterQuery_ALL_NextYear]";
            public const string TableNamePreviousYear = "[dbo].[vw_MasterQuery_ALL_PreviousYear]";

            public const string PeriodYear = "[PeriodYear]";
            public const string AccountLevelId = "[Account_Level_Id]";
            public const string AccountLevel1 = "[Account_Level_1]";
            public const string AccountLevel2 = "[Account_Level_2]";
            public const string AccountLevel3 = "[Account_Level_3]";
            public const string InitiativeId = "[Initiative_Id]";
            public const string InitiativeName = "[INITIATIVE_NAME]";
            public const string ProgramId = "[Program_Id]";
            public const string ProgramName = "[PROGRAM_NAME]";
            public const string ProjectId = "[Project_Id]";
            public const string ProjectName = "[PROJECT_NAME]";
            public const string ProgramManager = "[Program_Manager]";
            public const string ProgramStartDate = "[PROG_START_DATE]";
            public const string ProgramEndDate = "[PROG_END_DATE]";
            public const string ProgramTechnologyRollUp = "[PROGRAM_TECHNOLOGY_ROLLUP]";

            public const string ProjectStatus = "[PROJECT_STATUS]";
            public const string ProjectStartDate = "[PROJECT_START_DATE]";
            public const string ProjectEndDate = "[PROJECT_END_DATE]";
            public const string ProjectManager = "[PROJECT_MANAGER]";

            public const string BillingClientGocCode = "[Billing_Client_Goc_Code]";

            public const string Client3Name = "[Client_3_name]";
            public const string Client4Name = "[Client_4_name]";
            public const string Client5Name = "[Client_5_name]";
            public const string Client6Name = "[Client_6_name]";
            public const string Client7Name = "[Client_7_name]";
            public const string Client8Name = "[Client_8_name]";
            public const string Client9Name = "[Client_9_name]";
            public const string Client10Name = "[Client_10_NAME]";
            public const string ClientGocCode = "[CLIENT_GOC_CODE]";
            public const string ClientRegion = "[Client_Region]";

            public const string System5Name = "[System_5_name]";
            public const string System6Name = "[System_6_name]";
            public const string System7Name = "[System_7_name]";
            public const string System8Name = "[System_8_name]";
            public const string System9Name = "[System_9_name]";
            public const string System10Name = "[System_10_name]";
            public const string SystemGocCode = "[SYSTEM_GOC_CODE]";
            public const string SystemRegion = "[System_Region]";

            public const string Lob = "[LOB]";

            public const string RuntheBankBuildTheBank = "[RuntheBankBuildtheBank]";
            public const string ProgramProjectLinkIndicator = "[PROGRAM_PROJECT_LINK_INDICATOR]";
            public const string WorkTypeFinancials = "[Work Type Financials]";
            public const string InitiativeInvestimentCategory = "[INIT_INVEST_CATEGORY]";
            public const string ProgramInvestimentCategory = "[PROG_INVEST_CATEGORY]";
            public const string ProgramCapitalizedIndicator = "[PROG_CAPIND]";
            public const string ProgramStatus = "[PROGRAM_STATUS]";

            public const string ProjectCapitalization = "[Project_Capitalization]";

            public const string BowFlag = "[BOW Flag]";
            public const string BowFlag2 = "[BOW Flag2]";
            public const string ProjectType = "[Project_Type]";

            public const string ProgramCarryoverIndicator = "[PROGRAM_CARRYOVER_INDICATOR]";
            public const string TaxonomyName = "[TAXONOMYNAME]";

            public const string CuRate = "[CU_Rate]";
            public const string FirstOfProgramDesc = "[FirstOfPROGRAM_DESC]";
            public const string LobParent = "[LOB_PARENT]";
            public const string AdjustedFlag = "[Adjusted_Flag]";

            public const string January = "[January]";
            public const string February = "[February]";
            public const string March = "[March]";
            public const string April = "[April]";
            public const string May = "[May]";
            public const string June = "[June]";
            public const string July = "[July]";
            public const string August = "[August]";
            public const string September = "[September]";
            public const string October = "[October]";
            public const string November = "[November]";
            public const string December = "[December]";

            public const string YearToDate = "[YearToDate]";
            public const string FullYear = "[FullYear]";
        }

        public class Application
        {
            public const string TableName = "[dbo].[Application]";

            public const string Id = "[Application_Id]";
            public const string Name = "[App_Name]";
            public const string RetirementDate = "[Retirement_Date]";
        }

        public class FinancialType
        {
            public const string TableName = "[dbo].[vw_DimFinancialType]";

            public const string AccountLevelId = "[Account_Level_Id]";
            public const string AccountLevel1 = "[Account_Level_1]";
            public const string AccountLevel2 = "[Account_Level_2]";
            public const string AccountLevel3 = "[Account_Level_3]";
        }
    }
}